import openpyxl

myBook=openpyxl.load_workbook('员工表.xlsx')
mySheet=myBook.active
for myRow in range(mySheet.max_row,1,-1):
	myRank=mySheet[myRow][6].value
	myMark='★'
	mySheet[myRow][6].value=myMark*myRank
myBook.save('结果表-员式表.xlsx')